Use BD_SYS_ATENCIONES
Go
Create Procedure dbo.GRMaeRequerimiento_Aprobar(
   @iNumReq       int,
   @bAprobado     bit,
   @iCodUsuApro   int,
   @iCodUsuA      int,
   @vNomTer       varchar(20)
)
As
Begin

   Declare @dtFecAct datetime
   
   Set @dtFecAct = GETDATE()
   
   Update GRMaeRequerimiento
   Set bAprobado = @bAprobado,
       iCodUsuApro = @iCodUsuApro,
       dtFecApro = @dtFecAct,
       iCodUsuA = @iCodUsuA, 
       vNomTer = @vNomTer, 
       dtFecAct = @dtFecAct       
   Where iNumReq = @iNumReq 
   
End